package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class PostBankCardQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public PostBankCardQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_post_bank_card
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andPostCardIdIsNull() {
            addCriterion("post_card_id is null");
            return (Criteria) this;
        }

        public Criteria andPostCardIdIsNotNull() {
            addCriterion("post_card_id is not null");
            return (Criteria) this;
        }

        public Criteria andPostCardIdEqualTo(Long value) {
            addCriterion("post_card_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdNotEqualTo(Long value) {
            addCriterion("post_card_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anPostCardIdGreaterThan(Long value) {
            addCriterion("post_card_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdGreaterThanOrEqualTo(Long value) {
            addCriterion("post_card_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdLessThan(Long value) {
            addCriterion("post_card_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdLessThanOrEqualTo(Long value) {
            addCriterion("post_card_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdIn(List<Long> values) {
            addCriterion("post_card_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdNotIn(List<Long> values) {
            addCriterion("post_card_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdBetween(Long value1, Long value2) {
            addCriterion("post_card_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPostCardIdNotBetween(Long value1, Long value2) {
            addCriterion("post_card_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andRepayAccountIsNull() {
            addCriterion("repay_account is null");
            return (Criteria) this;
        }

        public Criteria andRepayAccountIsNotNull() {
            addCriterion("repay_account is not null");
            return (Criteria) this;
        }

        public Criteria andRepayAccountEqualTo(String value) {
            addCriterion("repay_account =", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountNotEqualTo(String value) {
            addCriterion("repay_account <>", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountGreaterThan(String value) {
            addCriterion("repay_account >", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountGreaterThanOrEqualTo(String value) {
            addCriterion("repay_account >=", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountLessThan(String value) {
            addCriterion("repay_account <", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountLessThanOrEqualTo(String value) {
            addCriterion("repay_account <=", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountLike(String value) {
            addCriterion("repay_account like", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountNotLike(String value) {
            addCriterion("repay_account not like", value, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountIn(List<String> values) {
            addCriterion("repay_account in", values, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountNotIn(List<String> values) {
            addCriterion("repay_account not in", values, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountBetween(String value1, String value2) {
            addCriterion("repay_account between", value1, value2, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andRepayAccountNotBetween(String value1, String value2) {
            addCriterion("repay_account not between", value1, value2, "repayAccount");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyIsNull() {
            addCriterion("express_company is null");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyIsNotNull() {
            addCriterion("express_company is not null");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyEqualTo(String value) {
            addCriterion("express_company =", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyNotEqualTo(String value) {
            addCriterion("express_company <>", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyGreaterThan(String value) {
            addCriterion("express_company >", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyGreaterThanOrEqualTo(String value) {
            addCriterion("express_company >=", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyLessThan(String value) {
            addCriterion("express_company <", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyLessThanOrEqualTo(String value) {
            addCriterion("express_company <=", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyLike(String value) {
            addCriterion("express_company like", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyNotLike(String value) {
            addCriterion("express_company not like", value, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyIn(List<String> values) {
            addCriterion("express_company in", values, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyNotIn(List<String> values) {
            addCriterion("express_company not in", values, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyBetween(String value1, String value2) {
            addCriterion("express_company between", value1, value2, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressCompanyNotBetween(String value1, String value2) {
            addCriterion("express_company not between", value1, value2, "expressCompany");
            return (Criteria) this;
        }

        public Criteria andExpressNoIsNull() {
            addCriterion("express_no is null");
            return (Criteria) this;
        }

        public Criteria andExpressNoIsNotNull() {
            addCriterion("express_no is not null");
            return (Criteria) this;
        }

        public Criteria andExpressNoEqualTo(String value) {
            addCriterion("express_no =", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotEqualTo(String value) {
            addCriterion("express_no <>", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoGreaterThan(String value) {
            addCriterion("express_no >", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoGreaterThanOrEqualTo(String value) {
            addCriterion("express_no >=", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLessThan(String value) {
            addCriterion("express_no <", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLessThanOrEqualTo(String value) {
            addCriterion("express_no <=", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoLike(String value) {
            addCriterion("express_no like", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotLike(String value) {
            addCriterion("express_no not like", value, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoIn(List<String> values) {
            addCriterion("express_no in", values, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotIn(List<String> values) {
            addCriterion("express_no not in", values, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoBetween(String value1, String value2) {
            addCriterion("express_no between", value1, value2, "expressNo");
            return (Criteria) this;
        }

        public Criteria andExpressNoNotBetween(String value1, String value2) {
            addCriterion("express_no not between", value1, value2, "expressNo");
            return (Criteria) this;
        }

        public Criteria andMailingAddressIsNull() {
            addCriterion("mailing_address is null");
            return (Criteria) this;
        }

        public Criteria andMailingAddressIsNotNull() {
            addCriterion("mailing_address is not null");
            return (Criteria) this;
        }

        public Criteria andMailingAddressEqualTo(String value) {
            addCriterion("mailing_address =", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressNotEqualTo(String value) {
            addCriterion("mailing_address <>", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressGreaterThan(String value) {
            addCriterion("mailing_address >", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressGreaterThanOrEqualTo(String value) {
            addCriterion("mailing_address >=", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressLessThan(String value) {
            addCriterion("mailing_address <", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressLessThanOrEqualTo(String value) {
            addCriterion("mailing_address <=", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressLike(String value) {
            addCriterion("mailing_address like", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressNotLike(String value) {
            addCriterion("mailing_address not like", value, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressIn(List<String> values) {
            addCriterion("mailing_address in", values, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressNotIn(List<String> values) {
            addCriterion("mailing_address not in", values, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressBetween(String value1, String value2) {
            addCriterion("mailing_address between", value1, value2, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andMailingAddressNotBetween(String value1, String value2) {
            addCriterion("mailing_address not between", value1, value2, "mailingAddress");
            return (Criteria) this;
        }

        public Criteria andPostDateIsNull() {
            addCriterion("post_date is null");
            return (Criteria) this;
        }

        public Criteria andPostDateIsNotNull() {
            addCriterion("post_date is not null");
            return (Criteria) this;
        }

        public Criteria andPostDateEqualTo(LocalDateTime value) {
            addCriterion("post_date =", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotEqualTo(LocalDateTime value) {
            addCriterion("post_date <>", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateGreaterThan(LocalDateTime value) {
            addCriterion("post_date >", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("post_date >=", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateLessThan(LocalDateTime value) {
            addCriterion("post_date <", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("post_date <=", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateLike(LocalDateTime value) {
            addCriterion("post_date like", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotLike(LocalDateTime value) {
            addCriterion("post_date not like", value, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateIn(List<LocalDateTime> values) {
            addCriterion("post_date in", values, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotIn(List<LocalDateTime> values) {
            addCriterion("post_date not in", values, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("post_date between", value1, value2, "postDate");
            return (Criteria) this;
        }

        public Criteria andPostDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("post_date not between", value1, value2, "postDate");
            return (Criteria) this;
        }

        public Criteria andBillingDayIsNull() {
            addCriterion("billing_day is null");
            return (Criteria) this;
        }

        public Criteria andBillingDayIsNotNull() {
            addCriterion("billing_day is not null");
            return (Criteria) this;
        }

        public Criteria andBillingDayEqualTo(String value) {
            addCriterion("billing_day =", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayNotEqualTo(String value) {
            addCriterion("billing_day <>", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayGreaterThan(String value) {
            addCriterion("billing_day >", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayGreaterThanOrEqualTo(String value) {
            addCriterion("billing_day >=", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayLessThan(String value) {
            addCriterion("billing_day <", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayLessThanOrEqualTo(String value) {
            addCriterion("billing_day <=", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayLike(String value) {
            addCriterion("billing_day like", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayNotLike(String value) {
            addCriterion("billing_day not like", value, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayIn(List<String> values) {
            addCriterion("billing_day in", values, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayNotIn(List<String> values) {
            addCriterion("billing_day not in", values, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayBetween(String value1, String value2) {
            addCriterion("billing_day between", value1, value2, "billingDay");
            return (Criteria) this;
        }

        public Criteria andBillingDayNotBetween(String value1, String value2) {
            addCriterion("billing_day not between", value1, value2, "billingDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayIsNull() {
            addCriterion("repay_day is null");
            return (Criteria) this;
        }

        public Criteria andRepayDayIsNotNull() {
            addCriterion("repay_day is not null");
            return (Criteria) this;
        }

        public Criteria andRepayDayEqualTo(String value) {
            addCriterion("repay_day =", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayNotEqualTo(String value) {
            addCriterion("repay_day <>", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayGreaterThan(String value) {
            addCriterion("repay_day >", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayGreaterThanOrEqualTo(String value) {
            addCriterion("repay_day >=", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayLessThan(String value) {
            addCriterion("repay_day <", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayLessThanOrEqualTo(String value) {
            addCriterion("repay_day <=", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayLike(String value) {
            addCriterion("repay_day like", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayNotLike(String value) {
            addCriterion("repay_day not like", value, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayIn(List<String> values) {
            addCriterion("repay_day in", values, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayNotIn(List<String> values) {
            addCriterion("repay_day not in", values, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayBetween(String value1, String value2) {
            addCriterion("repay_day between", value1, value2, "repayDay");
            return (Criteria) this;
        }

        public Criteria andRepayDayNotBetween(String value1, String value2) {
            addCriterion("repay_day not between", value1, value2, "repayDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayIsNull() {
            addCriterion("debit_day is null");
            return (Criteria) this;
        }

        public Criteria andDebitDayIsNotNull() {
            addCriterion("debit_day is not null");
            return (Criteria) this;
        }

        public Criteria andDebitDayEqualTo(String value) {
            addCriterion("debit_day =", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayNotEqualTo(String value) {
            addCriterion("debit_day <>", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayGreaterThan(String value) {
            addCriterion("debit_day >", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayGreaterThanOrEqualTo(String value) {
            addCriterion("debit_day >=", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayLessThan(String value) {
            addCriterion("debit_day <", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayLessThanOrEqualTo(String value) {
            addCriterion("debit_day <=", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayLike(String value) {
            addCriterion("debit_day like", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayNotLike(String value) {
            addCriterion("debit_day not like", value, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayIn(List<String> values) {
            addCriterion("debit_day in", values, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayNotIn(List<String> values) {
            addCriterion("debit_day not in", values, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayBetween(String value1, String value2) {
            addCriterion("debit_day between", value1, value2, "debitDay");
            return (Criteria) this;
        }

        public Criteria andDebitDayNotBetween(String value1, String value2) {
            addCriterion("debit_day not between", value1, value2, "debitDay");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountIsNull() {
            addCriterion("first_repay_amount is null");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountIsNotNull() {
            addCriterion("first_repay_amount is not null");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("first_repay_amount =", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("first_repay_amount <>", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("first_repay_amount >", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("first_repay_amount >=", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountLessThan(java.math.BigDecimal value) {
            addCriterion("first_repay_amount <", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("first_repay_amount <=", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountLike(java.math.BigDecimal value) {
            addCriterion("first_repay_amount like", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountNotLike(java.math.BigDecimal value) {
            addCriterion("first_repay_amount not like", value, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("first_repay_amount in", values, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("first_repay_amount not in", values, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("first_repay_amount between", value1, value2, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andFirstRepayAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("first_repay_amount not between", value1, value2, "firstRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountIsNull() {
            addCriterion("month_repay_amount is null");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountIsNotNull() {
            addCriterion("month_repay_amount is not null");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("month_repay_amount =", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("month_repay_amount <>", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("month_repay_amount >", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("month_repay_amount >=", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountLessThan(java.math.BigDecimal value) {
            addCriterion("month_repay_amount <", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("month_repay_amount <=", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountLike(java.math.BigDecimal value) {
            addCriterion("month_repay_amount like", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountNotLike(java.math.BigDecimal value) {
            addCriterion("month_repay_amount not like", value, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("month_repay_amount in", values, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("month_repay_amount not in", values, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("month_repay_amount between", value1, value2, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andMonthRepayAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("month_repay_amount not between", value1, value2, "monthRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountIsNull() {
            addCriterion("last_repay_amount is null");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountIsNotNull() {
            addCriterion("last_repay_amount is not null");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("last_repay_amount =", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("last_repay_amount <>", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("last_repay_amount >", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("last_repay_amount >=", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountLessThan(java.math.BigDecimal value) {
            addCriterion("last_repay_amount <", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("last_repay_amount <=", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountLike(java.math.BigDecimal value) {
            addCriterion("last_repay_amount like", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountNotLike(java.math.BigDecimal value) {
            addCriterion("last_repay_amount not like", value, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("last_repay_amount in", values, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("last_repay_amount not in", values, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("last_repay_amount between", value1, value2, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andLastRepayAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("last_repay_amount not between", value1, value2, "lastRepayAmount");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNull() {
            addCriterion("is_deleted is null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIsNotNull() {
            addCriterion("is_deleted is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeletedEqualTo(Integer value) {
            addCriterion("is_deleted =", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotEqualTo(Integer value) {
            addCriterion("is_deleted <>", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThan(Integer value) {
            addCriterion("is_deleted >", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_deleted >=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThan(Integer value) {
            addCriterion("is_deleted <", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("is_deleted <=", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedLike(Integer value) {
            addCriterion("is_deleted like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotLike(Integer value) {
            addCriterion("is_deleted not like", value, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedIn(List<Integer> values) {
            addCriterion("is_deleted in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotIn(List<Integer> values) {
            addCriterion("is_deleted not in", values, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

        public Criteria andIsDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("is_deleted not between", value1, value2, "isDeleted");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_post_bank_card
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}